If you currently manage time using custom fields and would like to migrate them to Oracle standard valid time, you may need to:
-
Version enable the tables with the valid time option so the VM_VALID field is added. If the table is already versioned, use the DBMS_WM.AlterVersionedTable to time enable the table.
-
Write an SQL Script to copy the values you currently have to the WM_VALID field.